Spring 2021 Course Syllabus
Course: POFI-2350- Section: 1H
Databases 		LSCPA Logo Image
Instructor Information
Instructor Adriane Champagne
E-mailchampagneam@lamarpa.edu
Phone(409) 984-6416
Office
Location:Madison Monroe Education - Room: 207
Hours:Monday & Wednesday 9:00-11:00 a.m. 1:15-2:15 p.m. Tuesday and Thursday 9:00-11:00 a.m. Subject to change
COVID 19 Information The Lamar State College Port Arthur (LSCPA) Student Code of Conduct COVID 19 Policy requires students who have been exposed to COVID 19 or diagnosed with COVID 19 to report their condition on the COVID 19 Notification Form (available via a link on the Student Code of Conduct COVID19 webpage). This information will be provided to the Dean of Student Services. In addition, this policy requires all students to wear face coverings in compliance with the criteria included in the policy. For more information please refer to the COVID 19 link on the LSCPA website.
Course Information
Description In-depth instruction of database theory and the practical applications of a database. This course is designed to be repeated multiple times to improve student proficiency.
Prerequisites None.
Learning Outcomes 1. Identifies all main ideas, supporting details, and vocabulary in reading material; demonstrates a full understanding of the reading. (PSLO ALPHA); measured by quiz.
2. Structure a database. (PSLO 3); measured by end of chapter Assessment assignment.
3. Create and format tables, forms (PSLO3), and reports.(PSLO 4); measured by end of chapter Assessment assignment.
4. Create and modify queries. (PSLO 3); measured by end of chapter Assessment assignment.
5. Manipulate data. (PSLO 3); measured by end of chapter Assessment assignment.
Core Objectives
Program Student Learning Outcomes PSLO ALPHA: Reading skills - Demonstrates comprehension of content-area reading material.
PSLO 1. Demonstrates professionalism in the administrative workplace.
PSLO 2. Uses appropriate business administration skills.
PSLO 3. Uses appropriate office software applications.
PSLO 4. Creates effective business documents by applying ethical communication practices.
PSLO 5. Evaluates business documents.
Textbooks Textbook Purchasing Statement: A student attending Lamar State College Port Arthur is not under any obligation to purchase a textbook from the college-affiliated bookstore. The same textbook may also be available from an independent retailer, including an online retailer.

NEW PERSP.MS.OFFICE 365+ACCESS 16'INTER
REQUIRED |By SHELLMAN EDITION: 17 PUBLISHER: CENGAGE L
~
ISBN: 9781305880290
~
Or Cengage Unlimited
Required

16GB Flash Drive (Required)
Lecture Topics
Outline		 Week 01/19/2021: Syllabus review, pre-test, Blackboard and Self Service Banner
Week 01/25/2021: Managing and Creating Access Tables; Chapter 1 of Access 2016 Level 1
Week 02/01/2021: Creating Relationship between Tables; Chapter 2 of Access 2016 Level 1
Week 02/08/2021: Performing Queries; Chapter 3 of Access 2016 Level 1
Week 02/15/2021: Performing Queries; Chapter 3 of Access 2016 Level 1
Week 02/22/2021: Review Problems Chapter 1-3
Week 03/01/2021: Creating and Modifying Tables in Design View; Chapter 4 of Access 2016 Level 1
Week 03/08/2021: Exam 1 and Project
~
Spring Break 03/15/2021-03/19/2021
~
Week 03/22/2021: Creating Forms; Chapter 5 of Access 2016 Level 1
Week 03/29/2021: March 15 - 19 Spring Break
Week 04/15/2021: Creating Reports and Mailing Labels; Chapter 6 of Access 2016 Level 1
Week 04/12/2021: Modifying, Filtering, and Viewing Data; Chapter 7 of Access 2016 Level 1
Week 04/19/2021: Modifying, Filtering, and Viewing Data; Chapter 7 of Access 2016 Level 1
Week 04/26/2021: Exporting and importing Data; Chapter 8 of Access 2016 Level 1
Week 05/03/2021: Review & Final Exam
~
Schedule is subject to change
Major Assignments
Schedule		 Course Schedule:
Week 1: Online learning survey
Week 2: Quiz and assignment- Managing and Creating Access Tables; Chapter 1
Week 3: Creating Relationship between Tables; Quiz and assignment Chapter 2
Week 4: Assignment-Performing Queries; Chapter 3
Week 5: Performing Queries; Quiz Chapter 3
Week 6: Review Case Problems Chapter 1-3
Week 7: Quiz Creating and Modifying Tables in Design View; assignment Chapter 4
Week 8: Exam 1 and Project Due
Week 9: Quiz Creating Forms; Chapter 5
~
March 15 - 19 Spring Break
~
Week 11: Assignment Creating Reports and Mailing Labels; Chapter 6
Week 12: Quiz Modifying, Filtering, and Viewing Data; Chapter 7
Week 13: Assignment Modifying, Filtering, and Viewing Data; Chapter 7
Week 14: Assignment Exporting and importing Data; Chapter 8
Week 15: Course Review &Final Exam

Schedule is subject to change
Final Exam Date May 10, 2021 - 10:1 AM   Through  May 10, 2021 - 12:30 PM
Grading Scale  90 - 100=A    80 - 89=B    70 - 79=C     60 - 69=D    Below 59 = F
Determination of
Final Grade		 Assignments and Quizzes - 60%, Exams - 40%
Course Policies
Instructor Policies I will not discuss your grades over the phone or by e-mail. If you want to discuss your grades, you must come to my office in person or schedule a virtual meeting on TEAMS.
~
Homework assignments will be given each week. Not all homework may be graded.
~
LATE WORK is highly discouraged and will incur a 25 point penalty for every day it is late. Due dates are given and enough time is given to complete all work. NO EXCEPTIONS.
~
Academic Policies:
Academic dishonesty will result in a zero on any academic work or exam in question; a second incidence of academic dishonesty on any academic work or exam in question will be handled based on campus policies and procedures with the department chair. This could result in the student being given an "F" for the course.
~
Exams: You must work alone while taking the exam. Cheating on exams is not acceptable and will be subject to violations of the Academic Dishonesty policy.
NO MAKE-UP EXAMS. If a student should miss an exam, at the end of the semester, the instructor will average all exam grades [including the zero(s)] to replace the zero for the missed exam.
EXAMPLE: 4 test grades: 100, 100, 0, 80 = 280; 280/4= 70; 70 will go in the place of the zero.; Test grades are now 100, 100, 70,80
~
Students must leave the classroom after exam is finished.
There will be a final exam. All students must take the exam on the scheduled date and time, and failure to do so will result in a 0 on the final exam.
~
Quizzes :
Weekly quizzes could be given covering the chapter studied that week. Dates for quizzes are listed on the Course Calendar and on the To do list. There will be no makeups for missed quizzes. Missed quizzes will receive a score of zero.
~
Other class policies: Every student MUST have a copy of the required textbooks by the second week of class. The student will still be responsible for any assignments given.
~
**No emailed work is accepted.**
Students are responsible for completing all assigned reading and video viewings. A failure to follow oral and/or written instructions will result in penalties.
~
Student IDs are required for the first exam. IDs must be visible on your desk before the exam is administered no ID, no exam. In an online course you could be required to show your student ID during an online Exam or meeting if requested.
~
Students should keep a record of their grades/average. Instructor(s) will not average grades for students. Instructors do not drop grades.
~
Software Requirements:
If you are in a course that is using a specific software, you MUST have the software available to you either on your home computer or you must use the open lab provided in the Gates Library.
**Reliable Internet access is required for all courses. Computer failure and lack of internet access are not acceptable excuses for missed assignments, projects, quizzes, or exams.
DO NOT wait until the last minutes to complete class work or exams.
~
Announcements
I will post announcements weekly, usually early in the week. These announcements indicate upcoming due dates and notes important to your success in this course. You should READ these Announcements every week. I also recommend using the BlackBoard app on your phone, with notifications, so that you immediately receive notices of new announcements for this class.
~
Classroom Etiquette:
The following behaviors will result in the student being asked during class time to cease the action and/or leave the classroom: using cell phones, talking, or keying while the instructor is giving instructions or during class discussions; leaving class early without informing the instructor; surfing the Internet during lecture; and displaying a rude or negative behavior toward the instructor or other students.
No cell phones should be visible or heard during class. Again, you will be asked to leave the room for the remainder of the class. No blue tooth technology or recording of lectures in any format (unless approved by the instructor). No charging of cell phones in the classroom.
~
E-Mail/Voice Mail Etiquette:
Students must use appropriate e-mail etiquette when corresponding with instructor; for example, complete sentences and a full subject line with your name/course name. Voice mail messages should be clearly spoken identifying students name, course, and any return phone number.
Attendance Policy Poor attendance is a leading reason for termination from a job in all areas of employment. With this factor in mind, the instructor monitors student attendance daily. In addition, attendance on a regular basis is necessary for proper skill development.
~
To be successful in this course, the student MUST purchase the assigned textbook and log into BlackBoard at least 2-3 times weekly. Regular, reliable access to BlackBoard via Internet is required for this online course. Attendance is monitored via Blackboard reports of logins and interaction with course.
~
Students are responsible for completing all assigned homework and for being prepared for each class face to face or online meeting. This applies even if you were absent for the previous class meeting.
Academic Honesty Academic honesty is expected from all students, and dishonesty in any form will not be tolerated. Please consult the LSC-PA policies (Section IX, subsection A, in the Faculty Handbook) for consequences of academic dishonesty.
Facility Policies
  1. No food or tobacco products are allowed in the classroom.

  2. Only students enrolled in the course are allowed in the classroom, except by special instructor permission.

  3. Use of electronic devices is prohibited.
Important Information
ADA Considerations The Americans with Disabilities Act (ADA) is a federal anti-discrimination statute that provides comprehensive civil rights for persons with disabilities. Among other things, this legislation requires that all students with disabilities be guaranteed a learning environment that provides for reasonable accommodation of their disabilities. If you believe you have a disability requiring an accommodation, please contact the the Office for Disability Services Coordinator, Room 231, in the Madison Monroe Building. The phone number is (409) 984-6241.
MyLSCPA Be sure to check your campus E-mail and Course Homepage using MyLSCPA campus web portal (My.LamarPA.edu). When you've logged in, click the email icon in the upper right-hand corner to check email, or click on the "My Courses" tab to get to your Course Homepage. Click the link to your course and review the information presented. It is important that you check your email and Course Homepage regularly. You can also access your grades, transcripts, and determine who your academic advisor is by using MyLSCPA.
Other
HB 2504 This syllabus is part of LSC-PA's efforts to comply with Texas House Bill 2504.
Department
Business and Industrial Technology
Chair:Sheila Guillot
E-mail:guillsr@lamarpa.edu
Phone:(409) 984-6381

If you have a grievance, complaint, or concern about this course that has not been resolved through discussion with the Instructor, please consult the Department Chair.